import MySQLdb
from sqlalchemy import create_engine
import pymssql

# CONNECT = MySQLdb.connect(host='127.0.0.1', user='root', passwd='',db='yumweb', port=3306,charset='utf8')
CONNECTRDATA = pymssql.connect(server='172.17.132.12', user='shen_monitor', password='dxs7735',
                               database='OrderCenter')
# ENGINE = create_engine('mysql://root:''@127.0.0.1:3306/test2?charset=utf8')

ENGINE = create_engine('mysql+pymysql://root:Dx_159357@127.0.0.1:3306/yumdata?charset=utf8',
                       echo=False)

# CONNECTDATA = MySQLdb.connect(host='127.0.0.1', user='root', passwd='',db='test2', port=3306,charset='utf8')

CONNECTDATA = MySQLdb.connect(host='127.0.0.1', user='root', passwd='Dx_159357',db='yumdata', port=3306,charset='utf8')
